<html>
<head><meta http-equiv="content-type" content="text/html; charset=UTF-8"></head>
<body>
<h5 align="right" style="color: gray; ">Snapshot on 2009-06-03 16:17:52</h5>
<h3>DATA DICT FOR : ECC_PROJECT</h3>
<br>
<h4>amphur_tab</h4>
<table border=1 width=75%>
<tr>
	<th width=35%>Field</th>
	<th width=30%>Type</th>
	<th width=15%>Allow Null</th>
	<th width=20%>Default Value</th>
</tr>
<tr>
	<td width=35% style="text-decoration: underline"><em>province_id</em></td>
	<td width=30%>int(10)</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขจังหวัด</td>
</tr>
<tr>
	<td width=35% style="text-decoration: underline"><em>amphur_id</em></td>
	<td width=30%>int(10)</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขอำเภอ</td>
</tr>
<tr>
	<td width=35%>amphur_name</td>
	<td width=30%>varchar(50)</td>
	<td width=15%>No</td>
	<td width=20%>ชื่ออำเภอ</td>
</tr>
<tr>
	<td width=35%>postcode</td>
	<td width=30%>varchar(5)</td>
	<td width=15%>No</td>
	<td width=20%>รหัสไปรษณีย์</td>
</tr>
</table>
<blockquote> <h4>Indices</h4>
	<table border=1 width=75%>
	<tr>
		<th width=35%>Name</th>
		<th width=30%>Type</th>
		<th width=35%>Field</th>


	</tr>
	<tr>
		<td><em>PRIMARY</em></td>
		<td>PRIMARY</td>
		<td>province_id,amphur_id</td>
	</tr>
	</table>
	<h4>Foreign Key</h4>
	<table border=1 width=75%>
	<tr>
		<th width=20%>Name</th>
		<th width=20%>Column</th>
		<th width=20%>Ref.Column</th>
		<th width=20%>On Update</th>		
		<th width=20%>On Delete</th>		

	</tr>
	<tr>
		<td>amphur_tab_ibfk_1</td>
		<td>province_id</td>
		<td>province_tab.province_id</td>
		<td>cascade</td>
		<td>cascade</td>
	</tr>
	</table>
</blockquote>
<br>
<h4>categories_tab</h4>
<table border=1 width=75%>
<tr>
	<th width=35%>Field</th>
	<th width=30%>Type</th>
	<th width=15%>Allow Null</th>
	<th width=20%>Default Value</th>
</tr>
<tr>
	<td width=35% style="text-decoration: underline"><em>Cat_ID</em></td>
	<td width=30%>varchar(3)</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลข CAT ID</td>
</tr>
<tr>
	<td width=35%>Cat_Name</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%>ชื่อหมวดหมู่วิชา</td>
</tr>
</table>
<blockquote> <h4>Indices</h4>
	<table border=1 width=75%>
	<tr>
		<th width=35%>Name</th>
		<th width=30%>Type</th>
		<th width=35%>Field</th>


	</tr>
	<tr>
		<td><em>PRIMARY</em></td>
		<td>PRIMARY</td>
		<td>cat_id</td>
	</tr>
	</table>
	<h4>Foreign Key</h4>
	<table border=1 width=75%>
	<tr>
		<th width=20%>Name</th>
		<th width=20%>Column</th>
		<th width=20%>Ref.Column</th>
		<th width=20%>On Update</th>		
		<th width=20%>On Delete</th>		

	</tr>
	<tr>
		<td colspan="5">No Foreign Key</td>
	</tr>
	</table>
</blockquote>
<br>
<h4>instructure_tab</h4>
<table border=1 width=75%>
<tr>
	<th width=35%>Field</th>
	<th width=30%>Type</th>
	<th width=15%>Allow Null</th>
	<th width=20%>Default Value</th>
</tr>
<tr>
	<td width=35% style="text-decoration: underline"><em>Instructure_ID</em></td>
	<td width=30%>int(10) unsigned zerofill</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขประจำตัวอาจารย์</td>
</tr>
<tr>
	<td width=35%>Instructure_User</td>
	<td width=30%>varchar(16)</td>
	<td width=15%>No</td>
	<td width=20%>ชื่อบัญชีผู้ใช้</td>
</tr>
<tr>
	<td width=35%>Instructure_Password</td>
	<td width=30%>varchar(32)</td>
	<td width=15%>No</td>
	<td width=20%>รหัสผ่าน MD5</td>
</tr>
<tr>
	<td width=35%>Instructure_Name</td>
	<td width=30%>varchar(50)</td>
	<td width=15%>No</td>
	<td width=20%>ชื่อจริง</td>
</tr>
<tr>
	<td width=35%>Instructure_Surname</td>
	<td width=30%>varchar(50)</td>
	<td width=15%>No</td>
	<td width=20%>นามสกุล</td>
</tr>
<tr>
	<td width=35%>Instructure_Citizen</td>
	<td width=30%>varchar(13)</td>
	<td width=15%>No</td>
	<td width=20%>บัตรประชาชน</td>
</tr>
<tr>
	<td width=35%>Instructure_BirthDate</td>
	<td width=30%>date</td>
	<td width=15%>No</td>
	<td width=20%>วันเกิด</td>
</tr>
<tr>
	<td width=35%>Instructure_Gender</td>
	<td width=30%>char(1)</td>
	<td width=15%>No</td>
	<td width=20%>เพศ</td>
</tr>
<tr>
	<td width=35%>Instructure_Addr</td>
	<td width=30%>longtext</td>
	<td width=15%>No</td>
	<td width=20%>ที่อยู่</td>
</tr>
<tr>
	<td width=35%>Instructure_Email</td>
	<td width=30%>varchar(50)</td>
	<td width=15%>No</td>
	<td width=20%>อีเมลล์</td>
</tr>
<tr>
	<td width=35%>Instructure_School_ID</td>
	<td width=30%>int(10) unsigned</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขอ้างอิงโรงเรียน</td>
</tr>
<tr>
	<td width=35%>AUX1</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX2</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX3</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX4</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX5</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX6</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX7</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX8</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX9</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX10</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
</table>
<blockquote> <h4>Indices</h4>
	<table border=1 width=75%>
	<tr>
		<th width=35%>Name</th>
		<th width=30%>Type</th>
		<th width=35%>Field</th>


	</tr>
	<tr>
		<td><em>PRIMARY</em></td>
		<td>PRIMARY</td>
		<td>Instructure_ID</td>
	</tr>
	<tr>
		<td>Instructure_PID</td>
		<td>Binary Tree</td>
		<td>Instructure_Citizen</td>
	</tr>
	<tr>
		<td>Instructure_Gender</td>
		<td>Binary Tree</td>
		<td>Instructure_Gender</td>
	</tr>
	<tr>
		<td>Instructure_School_ID</td>
		<td>Binary Tree</td>
		<td>Instructure_School_ID</td>
	</tr>
	</table>
	<h4>Foreign Key</h4>
	<table border=1 width=75%>
	<tr>
		<th width=20%>Name</th>
		<th width=20%>Column</th>
		<th width=20%>Ref.Column</th>
		<th width=20%>On Update</th>		
		<th width=20%>On Delete</th>		

	</tr>
	<tr>
		<td>instructure_tab_ibfk_1</td>
		<td>Instructure_School_ID</td>
		<td>School_tab.School_ID</td>
		<td>cascade</td>
		<td>cascade</td>
	</tr>
	</table>
</blockquote>
<br>
<h4>level_tab</h4>
<table border=1 width=75%>
<tr>
	<th width=35%>Field</th>
	<th width=30%>Type</th>
	<th width=15%>Allow Null</th>
	<th width=20%>Default Value</th>
</tr>
<tr>
	<td width=35% style="text-decoration: underline"><em>Level_ID</em></td>
	<td width=30%>varchar(2)</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลข IDชั้นเรียน M1,M2...M6</td>
</tr>
<tr>
	<td width=35%>Level_Name</td>
	<td width=30%>varchar(50)</td>
	<td width=15%>No</td>
	<td width=20%>ชื่อเรียกชั้นเรียน เช่น มัธยมศึกษาตอนต้น</td>
</tr>
</table>
<blockquote> <h4>Indices</h4>
	<table border=1 width=75%>
	<tr>
		<th width=35%>Name</th>
		<th width=30%>Type</th>
		<th width=35%>Field</th>


	</tr>
	<tr>
		<td><em>PRIMARY</em></td>
		<td>PRIMARY</td>
		<td>Level_ID</td>
	</tr>
	</table>
	<h4>Foreign Key</h4>
	<table border=1 width=75%>
	<tr>
		<th width=20%>Name</th>
		<th width=20%>Column</th>
		<th width=20%>Ref.Column</th>
		<th width=20%>On Update</th>		
		<th width=20%>On Delete</th>		

	</tr>
	<tr>
		<td colspan="5">No Foreign Key</td>
	</tr>
	</table>
</blockquote>
<br>
<h4>province_tab</h4>
<table border=1 width=75%>
<tr>
	<th width=35%>Field</th>
	<th width=30%>Type</th>
	<th width=15%>Allow Null</th>
	<th width=20%>Default Value</th>
</tr>
<tr>
	<td width=35% style="text-decoration: underline"><em>province_id</em></td>
	<td width=30%>int(10)</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขอ้างอิงจังหวัด</td>
</tr>
<tr>
	<td width=35%>province_name</td>
	<td width=30%>varchar(50)</td>
	<td width=15%>No</td>
	<td width=20%>ชื่อจังหวัด</td>
</tr>
</table>
<blockquote> <h4>Indices</h4>
	<table border=1 width=75%>
	<tr>
		<th width=35%>Name</th>
		<th width=30%>Type</th>
		<th width=35%>Field</th>


	</tr>
	<tr>
		<td><em>PRIMARY</em></td>
		<td>PRIMARY</td>
		<td>province_id</td>
	</tr>
	</table>
	<h4>Foreign Key</h4>
	<table border=1 width=75%>
	<tr>
		<th width=20%>Name</th>
		<th width=20%>Column</th>
		<th width=20%>Ref.Column</th>
		<th width=20%>On Update</th>		
		<th width=20%>On Delete</th>		

	</tr>
	<tr>
		<td colspan="5">No Foreign Key</td>
	</tr>
	</table>
</blockquote>
<br>
<h4>school_expire_date_tab</h4>
<table border=1 width=75%>
<tr>
	<th width=35%>Field</th>
	<th width=30%>Type</th>
	<th width=15%>Allow Null</th>
	<th width=20%>Default Value</th>
</tr>
<tr>
	<td width=35% style="text-decoration: underline"><em>School_ID</em></td>
	<td width=30%>int(10) unsigned zerofill</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขอ้างอิงโรงเรียน</td>
</tr>
<tr>
	<td width=35%>Expire_date</td>
	<td width=30%>datetime</td>
	<td width=15%>No</td>
	<td width=20%>วันหมดอายุการใช้งาน</td>
</tr>
</table>
<blockquote> <h4>Indices</h4>
	<table border=1 width=75%>
	<tr>
		<th width=35%>Name</th>
		<th width=30%>Type</th>
		<th width=35%>Field</th>


	</tr>
	<tr>
		<td><em>PRIMARY</em></td>
		<td>PRIMARY</td>
		<td>School_ID</td>
	</tr>
	</table>
	<h4>Foreign Key</h4>
	<table border=1 width=75%>
	<tr>
		<th width=20%>Name</th>
		<th width=20%>Column</th>
		<th width=20%>Ref.Column</th>
		<th width=20%>On Update</th>		
		<th width=20%>On Delete</th>		

	</tr>
	<tr>
		<td>school_expire_date_tab_ibfk_1</td>
		<td>School_ID</td>
		<td>School_tab.School_ID</td>
		<td>cascade</td>
		<td>cascade</td>
	</tr>
	</table>
</blockquote>
<br>
<h4>school_instructure_tab</h4>
<table border=1 width=75%>
<tr>
	<th width=35%>Field</th>
	<th width=30%>Type</th>
	<th width=15%>Allow Null</th>
	<th width=20%>Default Value</th>
</tr>
<tr>
	<td width=35% style="text-decoration: underline"><em>School_ID</em></td>
	<td width=30%>int(10) unsigned zerofill</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขอ้างอิงโรงเรียน</td>
</tr>
<tr>
	<td width=35% style="text-decoration: underline"><em>Instructure_ID</em></td>
	<td width=30%>int(10) unsigned zerofill</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขอ้างอิงอาจารย์ผู้สอน</td>
</tr>
</table>
<blockquote> <h4>Indices</h4>
	<table border=1 width=75%>
	<tr>
		<th width=35%>Name</th>
		<th width=30%>Type</th>
		<th width=35%>Field</th>


	</tr>
	<tr>
		<td><em>PRIMARY</em></td>
		<td>PRIMARY</td>
		<td>School_ID,Instructure_ID</td>
	</tr>
	<tr>
		<td>FK_school_instructure_tab_Instructure_ID</td>
		<td>Binary Tree</td>
		<td>Instructure_ID</td>
	</tr>
	</table>
	<h4>Foreign Key</h4>
	<table border=1 width=75%>
	<tr>
		<th width=20%>Name</th>
		<th width=20%>Column</th>
		<th width=20%>Ref.Column</th>
		<th width=20%>On Update</th>		
		<th width=20%>On Delete</th>		

	</tr>
	<tr>
		<td>school_instructure_ibfk_1</td>
		<td>School_ID</td>
		<td>school_tab.school_id</td>
		<td>cascade</td>
		<td>cascade</td>
	</tr>
	<tr>
		<td>school_instructure_ibfk_2</td>
		<td>Instructure_ID</td>
		<td>instructure_tab.Instructure_ID</td>
		<td>cascade</td>
		<td>cascade</td>
	</tr>
	</table>
</blockquote>
<br>
<h4>school_student_tab</h4>
<table border=1 width=75%>
<tr>
	<th width=35%>Field</th>
	<th width=30%>Type</th>
	<th width=15%>Allow Null</th>
	<th width=20%>Default Value</th>
</tr>
<tr>
	<td width=35% style="text-decoration: underline"><em>School_id</em></td>
	<td width=30%>int(10) unsigned zerofill</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขอ้างอิงโรงเรียน</td>
</tr>
<tr>
	<td width=35% style="text-decoration: underline"><em>UID</em></td>
	<td width=30%>int(10) unsigned zerofill</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขอ้างอิงนักเรียน</td>
</tr>
</table>
<blockquote> <h4>Indices</h4>
	<table border=1 width=75%>
	<tr>
		<th width=35%>Name</th>
		<th width=30%>Type</th>
		<th width=35%>Field</th>


	</tr>
	<tr>
		<td><em>PRIMARY</em></td>
		<td>PRIMARY</td>
		<td>School_ID,UID</td>
	</tr>
	<tr>
		<td><em>FK_school_student_tab_UID</em></td>
		<td>Binary Tree</td>
		<td>UID</td>
	</tr>	
	</table>
	<h4>Foreign Key</h4>
	<table border=1 width=75%>
	<tr>
		<th width=20%>Name</th>
		<th width=20%>Column</th>
		<th width=20%>Ref.Column</th>
		<th width=20%>On Update</th>		
		<th width=20%>On Delete</th>		

	</tr>
	<tr>
		<td>school_instructure_ibfk_1</td>
		<td>School_ID</td>
		<td>School_tab.School_ID</td>
		<td>cascade</td>
		<td>cascade</td>
	</tr>
	<tr>
		<td>school_instructure_ibfk_2</td>
		<td>UID</td>
		<td>user_tab.UID</td>
		<td>cascade</td>
		<td>cascade</td>
	</tr>
	</table>
</blockquote>
<br>
<h4>school_tab</h4>
<table border=1 width=75%>
<tr>
	<th width=35%>Field</th>
	<th width=30%>Type</th>
	<th width=15%>Allow Null</th>
	<th width=20%>Default Value</th>
</tr>
<tr>
	<td width=35% style="text-decoration: underline"><em>school_id</em></td>
	<td width=30%>int(10) unsigned zerofill</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขประจำโรงเรียน</td>
</tr>
<tr>
	<td width=35%>school_user</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%>ชื่อผู้ใช้เข้าระบบ</td>
</tr>
<tr>
	<td width=35%>school_pwd</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%>รหัสผ่านเข้าระบบ</td>
</tr>
<tr>
	<td width=35%>school_name</td>
	<td width=30%>varchar(200)</td>
	<td width=15%>No</td>
	<td width=20%>ชื่อโรงเรียน</td>
</tr>
<tr>
	<td width=35%>school_location</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%>ที่ตั้ง</td>
</tr>
<tr>
	<td width=35%>school_tel</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%>เบอร์โทรศัพท์</td>
</tr>
<tr>
	<td width=35%>school_fax</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%>เบอร์แฟกซ์</td>
</tr>
<tr>
	<td width=35%>school_website</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%>เวปไซต์</td>
</tr>
<tr>
	<td width=35%>school_email</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%>อีเมลล์</td>
</tr>
<tr>
	<td width=35%>school_instructure_no</td>
	<td width=30%>int(10)</td>
	<td width=15%>No</td>
	<td width=20%>จำนวนอาจารย์ในโรงเรียน</td>
</tr>
<tr>
	<td width=35%>school_student_no</td>
	<td width=30%>int(10)</td>
	<td width=15%>No</td>
	<td width=20%>จำนวนนักเรียนในโรงเรียน</td>
</tr>
<tr>
	<td width=35%>AUX1</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX2</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX3</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX4</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX5</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX6</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX7</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX8</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX9</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX10</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
</table>
<blockquote> <h4>Indices</h4>
	<table border=1 width=75%>
	<tr>
		<th width=35%>Name</th>
		<th width=30%>Type</th>
		<th width=35%>Field</th>


	</tr>
	<tr>
		<td><em>PRIMARY</em></td>
		<td>PRIMARY</td>
		<td>school_id</td>
	</tr>
	</table>
	<h4>Foreign Key</h4>
	<table border=1 width=75%>
	<tr>
		<th width=20%>Name</th>
		<th width=20%>Column</th>
		<th width=20%>Ref.Column</th>
		<th width=20%>On Update</th>		
		<th width=20%>On Delete</th>		

	</tr>
	<tr>
		<td colspan="5">No Foreign Key</td>
	</tr>
	</table>
</blockquote>
<br>
<h4>subjects_tab</h4>
<table border=1 width=75%>
<tr>
	<th width=35%>Field</th>
	<th width=30%>Type</th>
	<th width=15%>Allow Null</th>
	<th width=20%>Default Value</th>
</tr>
<tr>
	<td width=35% style="text-decoration: underline"><em>Subject_id</em></td>
	<td width=30%>int(10) unsigned zerofill</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขบทเรียน</td>
</tr>
<tr>
	<td width=35%>Cat_id</td>
	<td width=30%>varchar(3)</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขอ้างอิงหมวดหมู่</td>
</tr>
<tr>
	<td width=35%>Level_id</td>
	<td width=30%>varchar(2)</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขอ้างอิงชั้นเรียน</td>
</tr>
<tr>
	<td width=35%>Subject_name</td>
	<td width=30%>varchar(255)</td>
	<td width=15%>No</td>
	<td width=20%>ชื่อบทเรียน</td>
</tr>
<tr>
	<td width=35%>School_ID</td>
	<td width=30%>int(10) unsigned</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขอ้างอิงโรงเรียน</td>
</tr>
<tr>
	<td width=35%>Subject_datetime</td>
	<td width=30%>datetime</td>
	<td width=15%>No</td>
	<td width=20%>วันที่เริ่มสอนและเวลา</td>
</tr>
<tr>
	<td width=35%>rating</td>
	<td width=30%>decimal(4,2)</td>
	<td width=15%>No</td>
	<td width=20%>เรทติ้ง</td>
</tr>
<tr>
	<td width=35%>Status</td>
	<td width=30%>varchar(1)</td>
	<td width=15%>No</td>
	<td width=20%>สถานะ Y,N,P</td>
</tr>
<tr>
	<td width=35%>Instructure_id</td>
	<td width=30%>int(10) unsigned</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขอ้างอิงอาจารย์ผู้สอน</td>
</tr>
</table>
<blockquote> <h4>Indices</h4>
	<table border=1 width=75%>
	<tr>
		<th width=35%>Name</th>
		<th width=30%>Type</th>
		<th width=35%>Field</th>


	</tr>
	<tr>
		<td><em>PRIMARY</em></td>
		<td>PRIMARY</td>
		<td>Subject_id</td>
	</tr>
	<tr>
		<td><em>Cat_ID</em></td>
		<td>Binary Tree</td>
		<td>Cat_id</td>
	</tr>
	<tr>
		<td><em>Level_id</em></td>
		<td>Binary Tree</td>
		<td>Level_id</td>
	</tr>
	<tr>
		<td><em>School_id</em></td>
		<td>Binary Tree</td>
		<td>School_id</td>
	</tr>
	<tr>
		<td><em>Subject_datetime</em></td>
		<td>Binary Tree</td>
		<td>Subject_datetime</td>
	</tr>
	<tr>
		<td><em>Instructure_id</em></td>
		<td>Binary Tree</td>
		<td>Instructure_id</td>
	</tr>
	</table>
	<h4>Foreign Key</h4>
	<table border=1 width=75%>
	<tr>
		<th width=20%>Name</th>
		<th width=20%>Column</th>
		<th width=20%>Ref.Column</th>
		<th width=20%>On Update</th>		
		<th width=20%>On Delete</th>		

	</tr>
	<tr>
		<td>subjects_tab_ibfk_1</td>
		<td>Cat_id</td>
		<td>Categories_tab.Cat_ID</td>
		<td>cascade</td>
		<td>cascade</td>
	</tr>
	<tr>
		<td>subjects_tab_ibfk_2</td>
		<td>Level_ID</td>
		<td>Level_tab.Level_ID</td>
		<td>cascade</td>
		<td>cascade</td>
	</tr>
	<tr>
		<td>subjects_tab_ibfk_3</td>
		<td>School_ID</td>
		<td>School_tab.School_id</td>
		<td>cascade</td>
		<td>cascade</td>
	</tr>
	<tr>
		<td>subjects_tab_ibfk_4</td>
		<td>Instructure_id</td>
		<td>Instructure_tab.Instructure_ID</td>
		<td>cascade</td>
		<td>cascade</td>
	</tr>
	</table>
</blockquote>
<br>
<h4>subscribe_tab</h4>
<table border=1 width=75%>
<tr>
	<th width=35%>Field</th>
	<th width=30%>Type</th>
	<th width=15%>Allow Null</th>
	<th width=20%>Default Value</th>
</tr>
<tr>
	<td width=35% style="text-decoration: underline"><em>Subscribe_id</em></td>
	<td width=30%>int(10) unsigned zerofill</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขสมัครสมาชิกรับข่าว</td>
</tr>
<tr>
	<td width=35%>Subject_id</td>
	<td width=30%>int(10) unsigned zerofill</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขอ้างอิงบทเรียนที่ต้องการรับข่าว</td>
</tr>
<tr>
	<td width=35%>UID</td>
	<td width=30%>int(10) unsigned zerofill</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขอ้างอิงนักเรียน</td>
</tr>
<tr>
	<td width=35%>Attendance</td>
	<td width=30%>tinyint(1)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
</table>
<blockquote> <h4>Indices</h4>
	<table border=1 width=75%>
	<tr>
		<th width=35%>Name</th>
		<th width=30%>Type</th>
		<th width=35%>Field</th>


	</tr>
	<tr>
		<td><em>PRIMARY</em></td>
		<td>PRIMARY</td>
		<td>Subscribe_id</td>
	</tr>
	<tr>
		<td><em>Subject_ID</em></td>
		<td>Binary Tree</td>
		<td>Subject_id</td>
	</tr>
	<tr>
		<td><em>UID</em></td>
		<td>Binary Tree</td>
		<td>UID</td>
	</tr>
	</table>
	<h4>Foreign Key</h4>
	<table border=1 width=75%>
	<tr>
		<th width=20%>Name</th>
		<th width=20%>Column</th>
		<th width=20%>Ref.Column</th>
		<th width=20%>On Update</th>		
		<th width=20%>On Delete</th>		

	</tr>
	<tr>
		<td>subscribe_tab_ibfk_1</td>
		<td>Subject_id</td>
		<td>Subjects_tab.Subject_id</td>
		<td>cascade</td>
		<td>cascade</td>
	</tr>
	<tr>
		<td>subscribe_tab_ibfk_2</td>
		<td>UID</td>
		<td>user_tab.UID</td>
		<td>cascade</td>
		<td>cascade</td>
	</tr>
	</table>
</blockquote>
<br>
<h4>system_permission</h4>
<table border=1 width=75%>
<tr>
	<th width=35%>Field</th>
	<th width=30%>Type</th>
	<th width=15%>Allow Null</th>
	<th width=20%>Default Value</th>
</tr>
<tr>
	<td width=35% style="text-decoration: underline"><em>permission_id</em></td>
	<td width=30%>int(5) unsigned zerofill</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขกำหนดสิทธิ์</td>
</tr>
<tr>
	<td width=35%>permission_name</td>
	<td width=30%>varchar(50)</td>
	<td width=15%>No</td>
	<td width=20%>สิทธิ์ในการจัดการระบบ</td>
</tr>
</table>
<blockquote> <h4>Indices</h4>
	<table border=1 width=75%>
	<tr>
		<th width=35%>Name</th>
		<th width=30%>Type</th>
		<th width=35%>Field</th>


	</tr>
	<tr>
		<td><em>PRIMARY</em></td>
		<td>PRIMARY</td>
		<td>permission_id</td>
	</tr>
	</table>
	<h4>Foreign Key</h4>
	<table border=1 width=75%>
	<tr>
		<th width=20%>Name</th>
		<th width=20%>Column</th>
		<th width=20%>Ref.Column</th>
		<th width=20%>On Update</th>		
		<th width=20%>On Delete</th>		

	</tr>
	<tr>
		<td colspan="5">No Foreign Key</td>
	</tr>
	</table>
</blockquote>
<br>
<h4>system_username</h4>
<table border=1 width=75%>
<tr>
	<th width=35%>Field</th>
	<th width=30%>Type</th>
	<th width=15%>Allow Null</th>
	<th width=20%>Default Value</th>
</tr>
<tr>
	<td width=35% style="text-decoration: underline"><em>uid</em></td>
	<td width=30%>int(10) unsigned zerofill</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขสมาชิกจัดการระบบ</td>
</tr>
<tr>
	<td width=35%>username</td>
	<td width=30%>varchar(16)</td>
	<td width=15%>No</td>
	<td width=20%>ชื่อบัญชีเข้าสู่ระบบ</td>
</tr>
<tr>
	<td width=35%>password</td>
	<td width=30%>varchar(32)</td>
	<td width=15%>No</td>
	<td width=20%>รหัสผ่านเข้าสู่ระบบ</td>
</tr>
<tr>
	<td width=35%>permission_id</td>
	<td width=30%>int(5) unsigned zerofill</td>
	<td width=15%>No</td>
	<td width=20%>สิทธิ์การเข้าถึง</td>
</tr>
</table>
<blockquote> <h4>Indices</h4>
	<table border=1 width=75%>
	<tr>
		<th width=35%>Name</th>
		<th width=30%>Type</th>
		<th width=35%>Field</th>


	</tr>
	<tr>
		<td><em>PRIMARY</em></td>
		<td>PRIMARY</td>
		<td>uid</td>
	</tr>
	</table>
	<h4>Foreign Key</h4>
	<table border=1 width=75%>
	<tr>
		<th width=20%>Name</th>
		<th width=20%>Column</th>
		<th width=20%>Ref.Column</th>
		<th width=20%>On Update</th>		
		<th width=20%>On Delete</th>		

	</tr>
	<tr>
		<td colspan="5">No Foreign Key</td>
	</tr>
	</table>
</blockquote>
<br>
<h4>user_tab</h4>
<table border=1 width=75%>
<tr>
	<th width=35%>Field</th>
	<th width=30%>Type</th>
	<th width=15%>Allow Null</th>
	<th width=20%>Default Value</th>
</tr>
<tr>
	<td width=35% style="text-decoration: underline"><em>UID</em></td>
	<td width=30%>int(10) unsigned zerofill</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขประจำตัวนักเรียน</td>
</tr>
<tr>
	<td width=35%>Username</td>
	<td width=30%>varchar(16)</td>
	<td width=15%>No</td>
	<td width=20%>ชื่อในการเข้าสู่ระบบ</td>
</tr>
<tr>
	<td width=35%>Password</td>
	<td width=30%>varchar(32)</td>
	<td width=15%>No</td>
	<td width=20%>รหัสผ่าน MD5</td>
</tr>
<tr>
	<td width=35%>Reference</td>
	<td width=30%>int(10) unsigned zerofill</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขอ้างอิงโรงเรียน</td>
</tr>
<tr>
	<td width=35%>Name</td>
	<td width=30%>varchar(50)</td>
	<td width=15%>No</td>
	<td width=20%>ชื่อนักเรียน</td>
</tr>
<tr>
	<td width=35%>Surname</td>
	<td width=30%>varchar(50)</td>
	<td width=15%>No</td>
	<td width=20%>นามสกุลนักเรียน</td>
</tr>
<tr>
	<td width=35%>Citizen</td>
	<td width=30%>varchar(13)</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขบัตรประชาชน</td>
</tr>
<tr>
	<td width=35%>BirthDate</td>
	<td width=30%>date</td>
	<td width=15%>No</td>
	<td width=20%>วันเกิด</td>
</tr>
<tr>
	<td width=35%>StudentID</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%>หมายเลขประจำตัวนักเรียนในโรงเรียน</td>
</tr>
<tr>
	<td width=35%>Gender</td>
	<td width=30%>char(1)</td>
	<td width=15%>No</td>
	<td width=20%>เพศ</td>
</tr>
<tr>
	<td width=35%>Student_Address</td>
	<td width=30%>longtext</td>
	<td width=15%>No</td>
	<td width=20%>ที่อยู่</td>
</tr>
<tr>
	<td width=35%>Email</td>
	<td width=30%>varchar(50)</td>
	<td width=15%>No</td>
	<td width=20%>อีเมลล์</td>
</tr>
<tr>
	<td width=35%>AUX1</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX2</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX3</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX4</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX5</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX6</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX7</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX8</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX9</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
<tr>
	<td width=35%>AUX10</td>
	<td width=30%>varchar(45)</td>
	<td width=15%>No</td>
	<td width=20%></td>
</tr>
</table>
<blockquote> <h4>Indices</h4>
	<table border=1 width=75%>
	<tr>
		<th width=35%>Name</th>
		<th width=30%>Type</th>
		<th width=35%>Field</th>


	</tr>
	<tr>
		<td><em>PRIMARY</em></td>
		<td>PRIMARY</td>
		<td>UID</td>
	</tr>
	</table>
	<h4>Foreign Key</h4>
	<table border=1 width=75%>
	<tr>
		<th width=20%>Name</th>
		<th width=20%>Column</th>
		<th width=20%>Ref.Column</th>
		<th width=20%>On Update</th>		
		<th width=20%>On Delete</th>		

	</tr>
	<tr>
		<td colspan="5">No Foreign Key</td>
	</tr>
	</table>
</blockquote>

</body>
</html>